Pandora Case Tool: Triggers Generating for Cardinality Constraints in RDBMS
نویسندگان
چکیده
The cardinality constraint is one of the most important constraints that can be established in a conceptual model. Nevertheless, not all CASE tools for developing database support the validation of this constraint due to the complexity associated to the referential integrity rules. So that, the contribution of this work concerns to provide PANDORA CASE (a tool used for learning and developing database in internet) algorithms which can be used to generate triggers for enforcing the cardinality constraints of a given database. These triggers are full compatible with the standard SQL3.
منابع مشابه
Relational Database Schema Design and Application Generating Using Iis*case Tool
IIS*CASE is a software product, aimed at relational database schema design and generation of application prototypes. Database schema design is based on the concept of form type and on automatic inference of database constraints from the set of form types. Form types, database schema and menus serve as the input specification to the application generator. A methodology of using IIS*CASE in the i...
متن کاملDataSynth: Generating Synthetic Data using Declarative Constraints
A variety of scenarios such as database system and application testing, data masking, and benchmarking require synthetic database instances, often having complex data characteristics. We present DataSynth, a flexible tool for generating synthetic databases. DataSynth uses a simple and powerful declarative abstraction based on cardinality constraints to specify data characteristics, and uses sop...
متن کاملHolistic Source-centric Schema Mappings for XML-on-RDBMS
When hosting XML information on relational backends, a mapping has to be established between the schemas of the information source and the target storage repositories. A rich body of recent literature exists for mapping isolated components of the XML Schema to their relational counterparts, especially with regard to table configurations. However, for a viable realworld implementation, a holisti...
متن کاملFortuna: A Visualization Tool for Probabilistic Cardinality Constraints
Probabilistic cardinality constraints stipulate lower bounds on the marginal probability of cardinality constraints in probabilistic databases. The demo shows how the computation of Armstrong PCsketches helps design teams identify lower bounds that separate meaningful from meaningless probabilistic databases in an application domain.
متن کاملDeveloping a Tool for Analysing and Generating the fittest Urban Morphology based on Sky View Factor and Insolation: With a Case Study on Yazd
Urban morphology, including buildings’ typology and their configuration, affects sky view factor and insolation, which are two of the most influential parameters in urban microclimate. These become even more important in extreme environmental conditions. In this research, challenge was to generate various rule based urban morphologies in a parametric environment. Then, to evaluate them based on...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2003